Excel 2013 for Biological and Life Sciences Statistics by Thomas J. Quirk Meghan Quirk & Howard F. Horton

Author:Thomas J. Quirk, Meghan Quirk & Howard F. Horton
Language: eng
Format: epub
Publisher: Springer International Publishing, Cham

Now, let’s use the second formula for the two-group t-test which we use whenever either one group, or both groups, have a sample size less than 30.

Objective: To use Formula #2 for the two-group t-test when one or both groups have a sample size less than 30

Now, let’s look at the case when one or both groups have a sample size less than 30.

5.3 Formula #2: One or Both Groups Have a Sample Size Less Than 30

Suppose that you wanted to see if there was a geographic variation in body length (in mm) of queen honeybees in two different regions of the world (REGION A and REGION B). Suppose, further, that you have been asked to analyze the data from this study and to compare the body lengths of the two regions using the two-group t-test for independent samples. You decide to try out your new Excel skills on a small sample of queen honeybees from each region on the hypothetical data given in Fig. 5.12:

Fig. 5.12Worksheet Data for Body Length of Queen Honeybees (Practical Example)

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.